



           

using System;
using System.Collections.Generic;
using System.Web;
using System.Data.Common;
using Shohdi.DataHandler;
using System.Data;




namespace DatabaseComponent
{
    
    public partial class TicketTypeDB
    {
          //Write any additional methods or properties here 
          //Don't modify any genrated classes



        //public List<TicketType> SearchOrLike(ClassDataHandler con, TicketType obj)
        //{
        //    string strWhere = "";
        //    List<DbParameter> lstParameters = new List<DbParameter>();


        //    if (obj.ID != -1)
        //    {
        //        DbParameter prmID = con.createParameter();
        //        prmID.ParameterName = "@ID";
        //        prmID.DbType = DbType.Int64;
        //        if (obj.ID == null)
        //        {
        //            prmID.Value = DBNull.Value;
        //        }
        //        else
        //        {
        //            prmID.Value = obj.ID;
        //        }
        //        strWhere += " [ID]=@ID OR ";
        //        lstParameters.Add(prmID);
        //    }





        //    if (obj.TicketTypeNameAR != "")
        //    {
        //        DbParameter prmTicketTypeNameAR = con.createParameter();
        //        prmTicketTypeNameAR.ParameterName = "@TicketTypeNameAR";
        //        prmTicketTypeNameAR.DbType = DbType.String;
        //        if (obj.TicketTypeNameAR == null)
        //        {
        //            prmTicketTypeNameAR.Value = DBNull.Value;
        //        }
        //        else
        //        {
        //            prmTicketTypeNameAR.Value = obj.TicketTypeNameAR;
        //        }
        //        strWhere += " [TicketTypeNameAR] LIKE @TicketTypeNameAR OR ";
        //        lstParameters.Add(prmTicketTypeNameAR);
        //    }





        //    if (obj.TicketTypeNameEN != "")
        //    {
        //        DbParameter prmTicketTypeNameEN = con.createParameter();
        //        prmTicketTypeNameEN.ParameterName = "@TicketTypeNameEN";
        //        prmTicketTypeNameEN.DbType = DbType.String;
        //        if (obj.TicketTypeNameEN == null)
        //        {
        //            prmTicketTypeNameEN.Value = DBNull.Value;
        //        }
        //        else
        //        {
        //            prmTicketTypeNameEN.Value = obj.TicketTypeNameEN;
        //        }
        //        strWhere += " [TicketTypeNameEN] LIKE @TicketTypeNameEN OR ";
        //        lstParameters.Add(prmTicketTypeNameEN);
        //    }






        //    if (strWhere != "")
        //        strWhere = " where " + strWhere.Substring(0, strWhere.LastIndexOf("OR"));





        //    List<TicketType> lstRet = Select(con, "", strWhere, lstParameters.ToArray());

        //    return lstRet;
        //}


        //public List<TicketType> SearchOrLike(TicketType obj)
        //{
        //    ClassDataHandler con = new ClassDataHandler(_Connection, _Provider);

        //    con.OpenConnection();

        //    List<TicketType> lstRet = SearchOrLike(con, obj);

        //    con.CloseConnection();

        //    return lstRet;
        //}



    }

}

                        